<?php include_once('header.php'); ?>
<?php include_once('left_navigation.php'); ?>
<?php
include('../classess/class_affiliate_user.php');
$affUser = new affUser();
$affiliate_id = $_SESSION['id'];
$banks_details = $affUser->get_details($affiliate_id);
?>
<div class="col-lg-12"><!-- Start Middle Content Div-->
    <div class="box">
        <div class="row">
            <div class="col-lg-12" style="margin-top:-20px; text-align:center;">
                <div class="box" style="font-size:16px;">
                    Your Refrence URL is 
                    <a href="<?php echo ReferenceLink; ?>" target="_blank" style="text-decoration:none; color:blue; "><?php echo ReferenceLink; ?></a>	
                </div>
                
                <div class="box" style="font-size:16px;">
                    Your real  Money(Commission)Status Page and bank transfer details by Vipin Sir.
                </div>
                
            </div>
            <div class="col-lg-12">
                <div class="box">
                    <div class="box-header" data-original-title>
                        <h2><i class="fa fa-user"></i><span class="break"></span>Affiliate Money Status</h2>
                        <div class="box-icon">
                            <a href="table.html#" class="btn-minimize"><i class="fa fa-chevron-up"></i></a>
                            <a href="table.html#" class="btn-close"><i class="fa fa-times"></i></a>
                        </div>
                    </div>
                    <div class="box-content">	
                        <?php
                        if (isset($delete_activate_user)) {
                            ?>
                            <div class="alert alert-info">
                                <div style="float: right; width: 5%;"><button type="button" class="close" data-dismiss="alert">&times;</button></div>
                                <div style="float:left;width: 92%;word-wrap: break-word;"><?php echo $delete_activate_user; ?></div>
                                <div style="clear:both;"></div>							
                            </div>
                            <?php
                        }
                        ?>
                        <div class="search_box">
                            <div class="fl_left sel_label_search">Search:</div>
                            <div class="fl_left" style="width:60%;">									
                                <form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>?aff_mn=1" id="search_form" name="search_form">
                                    <input type="text" name="search_value" id="search_value" placeholder="Search" value="<?php if (isset($_POST['search_value'])) {
                            echo $_POST['search_value'];
                        } else {
                            echo '';
                        } if (isset($_GET['srch_value'])) {
                            echo $_GET['srch_value'];
                        } else {
                            echo '';
                        } ?>">&nbsp;
                                    <input type="submit" name="submit_search" id="submit_search" class="btn btn-blue srch_btn" value="Search">
                                </form>

                            </div>
                            <div class="clear_fix"></div>
                        </div>
                        <table class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>S No.</th>
                                    <th>User Name</th>
                                    <th>Email</th>
                                 <!--   <th>Commission Percentage</th>-->
                                    <th>Commission</th> 
                                    <th>Is Active</th>
                                    <th>Is Paid</th>
                                    <th>View Info</th>

                                </tr>
                            </thead>   
                            <tbody>
                                <?php
                                $rec_limit = 25;

                                $condition_search = '';
                                $value = '';
                                if (isset($_POST['search_value'])) {
                                    $value = trim($_POST['search_value']);

                                    if (!empty($value)) {
                                        $cond_where = 'AND ';
                                        $condition_search = $cond_where . " (username like '%" . $value . "%' OR email like '%" . $value . "%')";
                                    }
                                }

                                if (isset($_GET['srch_value'])) {
                                    $value = $_GET['srch_value'];

                                    if (!empty($value)) {
                                        $cond_where = 'AND ';

                                        $condition_search = $cond_where . " (username like '%" . $value . "%' OR email like '%" . $value . "%')";
                                    }
                                }

                                 $select_count_course = " select count(*)  
,(SELECT SUM(c.`commission`) AS total_user_commission FROM tbl_commission c LEFT JOIN  tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id`  WHERE c.`trainee_id` = u.`id` AND ud.`is_refund` = '0') as total_user_commission 
FROM tbl_user AS u 
WHERE  u.reffered_by = 'a_" . $_SESSION['id'] . "'  " . $condition_search . " ";
                                 

                               /* $select_count_course = "SELECT  count(*)  FROM tbl_user AS u 
JOIN tbl_commission AS c ON c.`trainee_id` = u.`id` 
JOIN tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id` 
WHERE  u.reffered_by = 'a_" . $_SESSION['id'] . "' AND ud.`is_refund` = '0'
GROUP BY u.username ORDER BY u.username DESC ";
*/
                                $result_count_course = mysql_query($select_count_course);

                                $row = mysql_fetch_array($result_count_course);
                                $rec_count = $row[0];

                                if (isset($_GET['page'])) {
                                    $page = $_GET['page'] + 1;
                                    $offset = $rec_limit * $page;
                                } else {
                                    $page = 0;
                                    $offset = 0;
                                }

                                $serial_number = $page * $rec_limit;

                                $left_rec = $rec_count - ($page * $rec_limit);




                              /*  $select_trainer = "SELECT  SUM(c.`commission`) as total_user_commission,u.id as user_id, u.*  FROM tbl_user AS u 
JOIN tbl_commission AS c ON c.`trainee_id` = u.`id` 
JOIN tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id` 
WHERE  u.reffered_by = 'a_" . $_SESSION['id'] . "' AND ud.`is_refund` = '0'
GROUP BY u.username ORDER BY u.username DESC LIMIT " . $offset . ", " . $rec_limit;
*/
                                $select_trainer = " 
SELECT  u.id AS user_id, u.*  
,(SELECT SUM(c.`commission`) AS total_user_commission FROM tbl_commission c LEFT JOIN  tbl_user_details AS ud ON c.`trainee_detail_id` = ud.`id`  WHERE c.`trainee_id` = u.`id` AND ud.`is_refund` = '0') as total_user_commission 
FROM tbl_user AS u 
WHERE  u.reffered_by = 'a_" . $_SESSION['id'] . "'  " . $condition_search . " 
GROUP BY u.username ORDER BY u.username DESC LIMIT " . $offset . ", " . $rec_limit;



                                $query_trainer = mysql_query($select_trainer) or die(mysql_error());

                                $i = 1;
                                if (mysql_num_rows($query_trainer) > 0) {
                                    $total_amount = '0';
                                    $pending_amount = '0';
                                    $paid_amount = '0';
                                    $chk_id = '';
                                    while ($row = mysql_fetch_array($query_trainer)) {
                                        $select_paidamount = "SELECT SUM(total_amount) AS total_amount FROM tbl_aff_transfer  WHERE at_affilate_id= '" . $_SESSION['id'] . "'";
                                        $query_paidamount = mysql_query($select_paidamount) or die(mysql_error());
                                        $total_paidamount = mysql_fetch_assoc($query_paidamount);
                                        if ($row['is_active'] && $row['is_paid']) {
                                            $total_amount += $row['total_user_commission'];
                                        }
                                        $paid_amount = $total_paidamount['total_amount'];
                                        $pending_amount = $total_amount - $total_paidamount['total_amount'];
                                        echo '<tr>
						<td>' . $i . '</td>
						<td>' . $row['username'] . '</td>
						<td>' . $row['email'] . '</td>';

                                        if ($row['is_active'] && $row['is_paid']) {
                                            echo '<td>$' . $row['total_user_commission'] . '</td>';
                                        } else {
                                            echo '<td></td>';
                                        }
                                        echo '<td>';
                                        if ($row['is_active']) {
                                            echo '<span class="label label-success">Active</span>';
                                        } else {
                                            echo '<span class="label label-default">Inactive</span>';
                                        }
                                        echo '</td>
												<td>';
                                        if ($row['is_paid']) {
                                            echo '<span class="label label-success">Yes</span>';
                                        } else {
                                            echo '<span class="label label-default">No</span>';
                                        }
                                        echo '</td>';
                                        echo '<td><a href="user_course.php?home=1&user_id=' . $row['user_id'] . '">View Info</a></td>
	</tr>
										';
                                        $i++;
                                    }
                                } else {
                                    echo '<tr>
					<td colspan="9" style="text-align:center;">No Records Found</td>
									</tr>';
                                }
                                ?>						
                            </tbody>

                        </table>  

                        <?php
                        echo '<ul class="pagination">';
                        if ($rec_count > $rec_limit) {
                            if ($page > 0 && $left_rec > $rec_limit) {
                                $last = $page - 2;
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li> ';
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                            } else if ($page == 0) {
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                            } else if ($left_rec < $rec_limit || $left_rec == $rec_limit) {
                                $last = $page - 2;
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li>';
                            }
                        }
                        echo '</ul>';
                        ?>
                        <br/><br/>

                        <?php
                        $select_value = "SELECT * FROM tbl_affiliate  WHERE id = '" . $_SESSION['id'] . "'";

                        $query_value = mysql_query($select_value) or die(mysql_error());
                        $withdrawData = mysql_fetch_assoc($query_value);
                        ?>
                        <div>
                            <p><b>Minimum Amount:</b>  $ <?php echo $withdrawData['withdraw_min_amount'];
                        ; ?></p>
                            <p><b>Maximum Amount:</b>  $ <?php echo $withdrawData['withdraw_max_amount']; ?></p>
                        </div>

                        <?php if ($total_amount != '') { ?>                                            
                            <p><b>Total Amount:</b>  $ <?php echo $total_amount; ?></p>
                        <?php } ?>
                        <?php if ($paid_amount != '') { ?>                                            
                            <p><b>Paid Amount:</b>  $ <?php echo $paid_amount; ?></p>
<?php } ?>
<?php //if($pending_amount != ''){ ?>                                            
                        <p><b>Pending Amount:</b>  $ <?php echo $pending_amount; ?></p>
<?php //} ?>



                    </div>

                </div>
            </div><!--/col-->

        </div><!--/row-->


        <div class="row">		

            <div class="col-lg-12">

                <div class="box">

                    <div class="box-header" data-original-title>

                        <h2><i class="fa fa-user"></i><span class="break"></span>Bank Detail</h2>

                        <div class="box-icon">

                            <a href="table.html#" class="btn-minimize"><i class="fa fa-chevron-up"></i></a>

                            <a href="table.html#" class="btn-close"><i class="fa fa-times"></i></a>

                        </div>

                    </div>

                    <div class="box-content">


                        <div class="search_box">


                            <div class="clear_fix"></div>

                        </div>

                        <table class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>S.No.</th>
                                    <th>Bank Name</th>
                                    <th>Account No.</th>
                                    <th>Transaction Id</th>
                                    <th>Transfer Amount</th>
                                    <th>Tds (%)</th>
                                    <th>Receive Amount</th>
                                    <th>Date</th>
                                    <th>Note</th>
                                </tr>

                            </thead>   

                            <tbody>

                                <?php
                                $rec_limits = 3;



                                $condition_search = '';

                                $value = '';

                                $select_count_detail = "SELECT count(at_id) FROM tbl_aff_transfer WHERE at_affilate_id= '" . $affiliate_id . "'" . $condition_search;

                                $result_count_detail = mysql_query($select_count_detail);



                                $row_detail = mysql_fetch_array($result_count_detail);

                                $rec_count_detail = $row_detail[0];



                                if (isset($_GET['pages'])) {

                                    $pages = $_GET['pages'] + 1;

                                    $offsets = $rec_limits * $pages;
                                } else {

                                    $pages = 0;

                                    $offsets = 0;
                                }
                                $serial_numbers = $pages * $rec_limits;
                                $left_recs = $rec_count - ($pages * $rec_limits);
                                $select_bank = "SELECT * FROM tbl_aff_transfer WHERE at_affilate_id= '" . $affiliate_id . "'" . $condition_search . " ORDER BY at_id DESC LIMIT " . $offset . ", " . $rec_limit;
                                $query_bank = mysql_query($select_bank) or die(mysql_error());

                                $i = 1;

                                if (mysql_num_rows($query_bank) > 0) {

                                    while ($rows = mysql_fetch_array($query_bank)) {

                                        $serial_numbers++;

                                        echo '
						<tr><td>' . $serial_numbers . '</td>
						<td>' . $rows['bank_name'] . '</td>
						<td>' . $rows['account_number'] . '</td>
        					<td>' . $rows['transaction_id'] . '</td>
						<td>$ ' . $rows['total_amount'] . '</td>
						<td>' . $rows['tds'] . '</td>
                                                    <td>$ ' . $rows['total_amount_with_tds'] . '</td>
						<td>' . $rows['at_date'] . '</td>
                                                <td>' . $rows['at_note'] . '</td>';
                                        echo '
        						</tr>

										';

                                        $i++;
                                    }
                                } else {

                                    echo '<tr>

										<td colspan="9" style="text-align:center;">No Records Found</td>

									</tr>';
                                }
                                ?>						

                            </tbody>

                        </table>  

                        <?php
                        echo '<ul class="pagination">';

                        if ($rec_count > $rec_limit) {

                            if ($page > 0 && $left_rec > $rec_limit) {

                                $last = $page - 2;

                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li> ';

                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                            } else if ($page == 0) {

                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                            } else if ($left_rec < $rec_limit || $left_rec == $rec_limit) {

                                $last = $page - 2;

                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?aff_mn=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li>';
                            }
                        }

                        echo '</ul>';
                        ?>

                    </div>

                </div>

            </div><!--/col-->



        </div><!--/row-->

    </div><!-- End Box Div-->
</div><!-- End Middle Content Div-->
<?php include_once('footer.php'); ?>
<script>
    $ = jQuery.noConflict();
    $(document).ready(function() {
        $('.close').click(function() {
            $('.alert-info').addClass('hide');
        });

        $('#add_user').click(function() {
            document.add_course_form.submit();
        });

        $('#submit_course_search').click(function() {
            document.search_course_form.submit()
        });
    });


</script>